Chapter 1 Working with IDBac from Python

## 'data/python_output/1.html'
## <sqlite3.Connection object at 0x0000000029B004E0>
## <sqlite3.Cursor object at 0x000000002AF102D0>
## [(1919,), (1919,), (60,), (60,)]
## <sqlite3.Cursor object at 0x000000002AF102D0>
## <class 'tuple'>

Get 172-1 sample peak lists as pandas df:

##                                          peak_matrix
## 0  {"mass":[1919.93905,1925.71302,1945.99421,1959...
## 1  {"mass":[1919.93905,1925.91941,1946.20174,1959...
## 2  {"mass":[61.28432,70.25831,72.2628,74.2751,75....
## 3  {"mass":[61.28972,70.25253,72.25693,74.2751,75...
## <class 'dict'>
##             mass  intensity       snr
## 0     1919.93905   64.32751  75.24010
## 1     1925.71302   37.17911  43.48622
## 2     1945.99421    7.45092   8.71490
## 3     1959.29976   15.17239  17.74625
## 4     1973.28037   38.34066  44.84481
## ..           ...        ...       ...
## 165  10720.96664    2.97231   3.47653
## 166  11036.57515    2.58138   3.01929
## 167  11601.65465    2.68094   3.13574
## 168  12404.30272    3.16847   3.70597
## 169  20136.84362    2.63911   3.08681
## 
## [170 rows x 3 columns]
## 1925.71302